Model Table LINEAR ASSET

This model dimension represents the Linear Assets and is based on the IFS Cloud dimension DIM_LINAST_LINEAR_ASSET. All models that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute Description (where applicable)
ClassClass of the Design Object connected to Linear Asset
DescriptionDescription
Design Object IdDesign Object ID Connected to Linear Asset
Design StatusDesign Status
Item Class IdThe identity of the item class used to hold failure analysis data
LengthLength + Unit Code Length
Linear AssetLinear Asset Name + Description
Linear Asset NameLinear Asset Name
Linear Asset Revision NoRevision Number of the Linear Asset
Linear Asset TypeLinear Asset Type Code
Operational StatusOperational Status Description
PlantPlant of the Design Object connected to the Linear Asset
Revision StatusThe Status of the Linear Asset Revision
SiteSite Code
Unit Code LengthThe unit of measure used for the linear asset length
Unit Code OffsetThe unit of measure used for the offsets

USED BY MODEL(S)

Model Name
Maintenance

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
LINEAR ASSETDIM_LINAST_LINEAR_ASSET_TMDIM_LINAST_LINEAR_ASSET_BIDIM_LINAST_LINEAR_ASSETOn Line